USE [HR_DB]
GO
if exists(select * from dbo.sysobjects where id = object_id(N'engage_resume')   and   OBJECTPROPERTY(id,   N'IsUserTable')   =   1)   
  drop table engage_resume  
-- =============================================
-- Author:杨洁(kaixuanpisces)
-- Create date: 20090826
-- Description:简历管理
-- =============================================
CREATE TABLE [dbo].[engage_resume](
	[res_id] [smallint] IDENTITY(1,1) NOT NULL,
	[human_name] [varchar](60) NULL,
	[engage_type] [varchar](30) NULL,
	[human_address] [varchar](200) NULL,
	[human_postcode] [varchar](10) NULL,
	[human_major_kind_id] [char](2) NULL,
	[human_major_kind_name] [varchar](60) NULL,
	[human_major_id] [char](2) NULL,
	[human_major_name] [varchar](60) NULL,
	[human_telephone] [varchar](60) NULL,
	[human_homephone] [varchar](60) NULL,
	[human_mobilephone] [varchar](60) NULL,
	[human_email] [varchar](60) NULL,
	[human_hobby] [varchar](200) NULL,
	[human_specility] [varchar](200) NULL,
	[human_sex] [char](2) NULL,
	[human_religion] [varchar](60) NULL,
	[human_party] [varchar](60) NULL,
	[human_nationality] [varchar](60) NULL,
	[human_race] [varchar](60) NULL,
	[human_birthday] [datetime] NULL,
	[human_age] [smallint] NULL,
	[human_educated_degree] [varchar](60) NULL,
	[human_educated_years] [smallint] NULL,
	[human_educated_major] [varchar](60) NULL,
	[human_college] [varchar](60) NULL,
	[human_idcard] [varchar](60) NULL,
	[human_birthplace] [varchar](200) NULL,
	[demand_salary_standard] [numeric](15, 2) NULL,
	[human_history_records] [text] NULL,
	[remark] [text] NULL,
	[recomandation] [text] NULL,
	[human_picture] [varchar](60) NULL,
	[attachment_name] [varchar](60) NULL,
	[check_status] [smallint] NULL,
	[register] [int] NULL,
	[regist_time] [datetime] NULL,
	[checker] [int] NULL,
	[check_time] [datetime] NULL,
	[interview_status] [smallint] NULL,
	[total_points] [float] NULL,
	[test_amount] [smallint] NULL,
	[test_checker] [varchar](60) NULL,
	[test_check_time] [datetime] NULL,
	[pass_register] [varchar](60) NULL,
	[pass_regist_time] [datetime] NULL,
	[pass_checker] [varchar](60) NULL,
	[pass_check_time] [datetime] NULL,
	[pass_check_status] [smallint] NULL,
	[pass_checkComment] [varchar](60) NULL,
	[pass_passComment] [varchar](60) NULL,
 CONSTRAINT [engage_resume_PK] PRIMARY KEY CLUSTERED 
(
	[res_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-- ==============================================
-- 列名说明
-- ==============================================
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键，自动增长列' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'res_id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'招聘类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'engage_type'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_address'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'邮编' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_postcode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职位分类编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_major_kind_id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职位分类名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_major_kind_name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职位编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_major_id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职位名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_major_name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电话号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_telephone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'家庭电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_homephone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'手机' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_mobilephone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Email' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_email'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'兴趣爱好' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_hobby'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'特长' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_specility'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_sex'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'宗教信仰' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_religion'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'政治面貌' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_party'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'国籍' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_nationality'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'民族' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_race'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生日' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_birthday'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年龄' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_age'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'教育程度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_educated_degree'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'教育年限' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_educated_years'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'专业' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_educated_major'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'毕业院校' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_college'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'身份证号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_idcard'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出生地' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_birthplace'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'薪酬标准' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'demand_salary_standard'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'个人履历' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_history_records'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'推荐意见' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'recomandation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'照片' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'human_picture'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'档案附件' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'attachment_name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'复核状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'check_status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登记人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'register'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登记时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'regist_time'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'复核人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'checker'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'复核时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'check_time'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'面试状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'interview_status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'总分' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'total_points'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'考试次数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'test_amount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'测试复核人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'test_checker'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'测试复核时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'test_check_time'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'通过登记人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'pass_register'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'通过登记时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'pass_regist_time'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'通过复核人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'pass_checker'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'通过复核时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'pass_check_time'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'通过的复核状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'pass_check_status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'录用申请审核意见' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'pass_checkComment'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'录用申请审批意见' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'engage_resume', @level2type=N'COLUMN',@level2name=N'pass_passComment'